Import wiki - foreign key constraint error

Hi there,

I have an urgent problem with importing wikis in Mountain Lion (10.8.2 / OS X Server 2.1).

What I did: under Lion did a "wikiadmin export", migrated a Lion Server to ML / OS X Server (10.8.2 / 2.1) and did a "wikiadmin export" again. Then I did a complete new installation of the server, erasing the disk, an installing ML 10.8.2 from scratch (copied it to an USB thumb drive before). Installed OS X Server 2.1. on top of it.

Now, after activationg Wikis in Server app, created a test wiki (OK) and the tried to reimport the old Wikis (from the ML export). But non succeeded. Every time the error goes like this:

ep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=3

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:233 75bb2180 +0ms] Executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_FATAL_ERROR] rows returned=0/updated=

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Error>: [PGCConnection:148 75bb2180 +0ms] Error in TXN: Error executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]: ERROR: insert or update on table "file_entity" violates foreign key constraint "file_entity_data_uid_fk_fkey"

DETAIL: Key (data_uid_fk)=(caceea67-37ca-4cac-a1d3-160e129cb7f7) is not present in table "filedata_entity".

(

0 CoreFoundation 0x00007fff86b520a6 __exceptionPreprocess + 198

1 libobjc.A.dylib 0x00007fff870ed3f0 objc_exception_throw + 43

2 PostgreSQLClient 0x00000001086fc9ae -[PGCConnection checkResultOK:forSQL:] + 360

3 PostgreSQLClient 0x00000001086fcec3 -[PGCConnection executeQuery:] + 223

4 wikiadmin 0x000000010869e576 wikiadmin + 66934

5 PostgreSQLClient 0x00000001086fc5f7 -[PGCConnection transactionInBlock:onError:] + 147

6 wikiadmin 0x000000010869dc86 wikiadmin + 64646

7 wikiadmin 0x00000001086ad6be wikiadmin + 128702

8 wikiadmin 0x0000000108693fa3 wikiadmin + 24483

9 libdyld.dylib 0x00007fff898e87e1 start + 0

10 ??? 0x0000000000000004 0x0 + 4

)

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:320 75bb2180 +0ms] Executing update [ROLLBACK]

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

2012-09-26 21:10:28.413 wikiadmin[17249:707] *** Terminating app due to uncaught exception 'PGCQueryError', reason: 'Error executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]: ERROR: insert or update on table "file_entity" violates foreign key constraint "file_entity_data_uid_fk_fkey"

DETAIL: Key (data_uid_fk)=(caceea67-37ca-4cac-a1d3-160e129cb7f7) is not present in table "filedata_entity".

'

*** First throw call stack:

(

0 CoreFoundation 0x00007fff86b520a6 __exceptionPreprocess + 198

1 libobjc.A.dylib 0x00007fff870ed3f0 objc_exception_throw + 43

2 PostgreSQLClient 0x00000001086fc9ae -[PGCConnection checkResultOK:forSQL:] + 360

3 PostgreSQLClient 0x00000001086fcec3 -[PGCConnection executeQuery:] + 223

4 wikiadmin 0x000000010869e576 wikiadmin + 66934

5 PostgreSQLClient 0x00000001086fc5f7 -[PGCConnection transactionInBlock:onError:] + 147

6 wikiadmin 0x000000010869dc86 wikiadmin + 64646

7 wikiadmin 0x00000001086ad6be wikiadmin + 128702

8 wikiadmin 0x0000000108693fa3 wikiadmin + 24483

9 libdyld.dylib 0x00007fff898e87e1 start + 0

10 ??? 0x0000000000000004 0x0 + 4

)

libc++abi.dylib: terminate called throwing an exception

Abort trap: 6

Please help!

Kind regards,

Carsten